from sqlalchemy.orm import Mapped, mapped_column, relationship
from settings.publicvar import Base
from sqlalchemy import String, ForeignKey
from datetime import date
from typing_extensions import Annotated

int_pk = Annotated[int,mapped_column(primary_key=True)]
nameset = Annotated[str,mapped_column(String(15),nullable=True)]

date_set = Annotated[date,mapped_column(nullable=True)]

class IssuedPersonSure(Base):
    __tablename__ = 'issuedpersonsure'

    id: Mapped[int_pk]
    school:Mapped[str]
    name:Mapped[str]
    IDcard:Mapped[str]
    bankName:Mapped[str]
    cardNumber:Mapped[str]
    openbank: Mapped[str]
    amount:Mapped[float]
    paymenttype:Mapped[str]
    persontype:Mapped[str]
    issueddate:Mapped[date_set]
    purpose:Mapped[str]
    uniqueID:Mapped[str]
    mark:Mapped[str] = mapped_column(nullable=True)
